How can I optimize a slow MySQL query involving multiple large tables

join shbcf.ru